Aggregate Query and display highest value of non-aggregated columns

join shbcf.ru